PositionHierarchy

Entity Definition

Logical Name : PositionHierarchy
Physical Name : ST_HRC_PST

The reporting structure of POSTIONs.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
Subordinate (FK)(PK) A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. ID_PST_SUB Identity integer Position(CO_PST)
Supervisor (FK)(PK) A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. ID_PST_SPVR Identity integer Position(CO_PST)
EffectiveDate The valid start date for a position's reporting structure DC_EF EffectiveDate date
ExpirationDate The date that a position's reporting structure is no longer valid. DC_EX ExpirationDate date

Relationships

Parent Entity Verb Phrase Child Entity
Position supervises PositionHierarchy
Position is subordinate to PositionHierarchy

Logical Views containing PositionHierarchy

Logical View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View